Accessing Microsoft Access Database in VB.NET

In this article, I will show you how to access Microsoft database using OLEDB 

data provider

Connection String:
       The ADO model uses the Connection String property to indicate the 
OLEDB provider to use to connect to data store, along with the details needed
 to complete the data connection.

          

A typical connection String has two parts:
     Provider :< Provider name>; Data Source=<Source Details>
 
 A valid connection for connecting to Microsoft Access database:
     Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C: student.mdb
 


Used namespace:       

Imports System
Imports System.Data

Imports System.Data.OleDb         

Inserting data into MS Access Database by VB.NET 2005 
Private Sub insert_Click(ByVal sender As System.Object,ByVal
e As System.EventArgs) Handles Insert.Click        
 
Dim con As OleDbConnection
Dim sql,str As String
str = "Provider=Microsoft.Jet.oledb.4.0;Data  Source=
C:student.mdb;"
con = New OleDbConnection(str)
sql = "insert into students(name,roll,mobile,email) 
values('" & sname.Text & "','" & roll.Text & "',
'" & mobile.Text & "','"& email.Text & "')" 
  Dim cmd As OleDbCommand   
   Try
      con.Open()
      cmd = New OleDbCommand(sql, con)
      cmd.ExecuteNonQuery() 
      sname.Text = "" 
      roll.Text = ""            
      mobile.Text = ""
      email.Text = ""   
      MessageBox.Show("Insert Successfully")
      con.Close()   
  Catch ex As OleDbException   
    MsgBox(ex.Message, MsgBoxStyle.Critical, "Oledb Error") 
  Catch ex As Exception
    MsgBox(ex.Message, MsgBoxStyle.Critical, "General Error")   
  End Try  
End Sub